﻿CREATE TABLE [dbo].[customer_in_category] (
    [CustomerID] INT NOT NULL,
    [CategoryID] INT NOT NULL,
    PRIMARY KEY CLUSTERED ([CustomerID] ASC, [CategoryID] ASC),
    CONSTRAINT [FK_customer_in_category_customer_categories] FOREIGN KEY ([CategoryID]) REFERENCES [dbo].[customer_categories] ([ID]) ON DELETE CASCADE,
    CONSTRAINT [FK_customer_in_category_customers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[customers] ([ID]) ON DELETE CASCADE
);

